SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Newton, MA') ORDER BY assigned_to ASC, date, patent, type |
Total of 6 patents found where: Residence is 'Newton, MA';
View a patent by clicking on the patent number. You can sort by any of the columns by clicking on the column name.
T / S | Patent | Date | Description | Patentee | Category | Assigned To |
U | 53,426 | March 27, 1866 | Improvement in Telegraph Insulators Hook covered with rubber attached to rubber hollow ball chamber |
ELY, Alfred B. |
Hook | |
U | 53,427 | March 27, 1866 | Improvement in Telegraph Insulators Hook fitted with a disk of rubber |
ELY, Alfred B. |
Hook | |
U | 386,111 | July 17, 1888 | Electric Wire Insulator Knobs paired to hold wire in trees |
CUTLER, Henry H. |
Knob | |
U | 517,591 | April 3, 1894 | Insulating Tube Wall tube with longitudinal fin ribs |
ROBINSON, Miner |
Wall Tube | |
U | 626,065 | May 30, 1899 | Insulator Tree hanger |
HOLMES, Welles E. |
Tree | |
John S. Potter | ||||||
U | 444,317 | January 6, 1891 | Electric Wire Insulating Cleat Cleat |
POTTER, John S. CARTWRIGHT, David J. |
Cleat | John S. Potter |
Total of 0.01 seconds